#!/usr/bin/python2.7
#coding=utf8
import datetime
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Index, Sequence, BigInteger, Integer, DateTime, Numeric, String, Unicode, UnicodeText, Text

Base = declarative_base()


class T_Ygb_Cjl (Base):
    __tablename__="T_YGB_CJL" 
    id = Column(BigInteger, Sequence("seq_t_ygb_cjl_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    cjl_zl = Column(Numeric(18,2), nullable=True)
    cjl_tb = Column(Numeric(10,4), nullable=True)
    cjl_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_cjl_unique', T_Ygb_Cjl.yyb_id,T_Ygb_Cjl.jzrq,T_Ygb_Cjl.tjzq,T_Ygb_Cjl.ywzl, unique=True)



class T_Ygb_Scfe (Base):
    __tablename__="T_YGB_SCFE" 
    id = Column(BigInteger, Sequence("seq_t_ygb_scfe_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    fe_zl = Column(Numeric(18,2), nullable=True)
    fe_tb = Column(Numeric(10,4), nullable=True)
    fe_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_scfe_unique', T_Ygb_Scfe.yyb_id,T_Ygb_Scfe.jzrq,T_Ygb_Scfe.tjzq,T_Ygb_Scfe.ywzl, unique=True)



class T_Ygb_Yjsr (Base):
    __tablename__="T_YGB_YJSR" 
    id = Column(BigInteger, Sequence("seq_t_ygb_yjsr_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    yj_zl = Column(Numeric(18,2), nullable=True)
    yj_tb = Column(Numeric(10,4), nullable=True)
    yj_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_yjsr_unique', T_Ygb_Yjsr.yyb_id,T_Ygb_Yjsr.jzrq,T_Ygb_Yjsr.tjzq,T_Ygb_Yjsr.ywzl, unique=True)



class T_Ygb_Yjf (Base):
    __tablename__="T_YGB_YJF" 
    id = Column(BigInteger, Sequence("seq_t_ygb_yjf_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    yjfl_zl = Column(Numeric(10,4), nullable=True)
    yjfl_tb = Column(Numeric(10,4), nullable=True)
    yjfl_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_yjf_unique', T_Ygb_Yjf.yyb_id,T_Ygb_Yjf.jzrq,T_Ygb_Yjf.tjzq,T_Ygb_Yjf.ywzl, unique=True)



class T_Ygb_Jykh (Base):
    __tablename__="T_YGB_JYKH" 
    id = Column(BigInteger, Sequence("seq_t_ygb_jykh_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    ywzl = Column(Integer, nullable=False)
    khzs = Column(Integer, nullable=True)
    jykh_zl = Column(Integer, nullable=True)
    jykh_zb = Column(Numeric(10,4), nullable=True)
    jykh_tb = Column(Numeric(10,4), nullable=True)
    jykh_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_jykh_unique', T_Ygb_Jykh.yyb_id,T_Ygb_Jykh.jzrq,T_Ygb_Jykh.ywzl, unique=True)



class T_Ygb_Zc (Base):
    __tablename__="T_YGB_ZC" 
    id = Column(BigInteger, Sequence("seq_t_ygb_zc_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    zc_zl = Column(Numeric(18,2), nullable=True)
    zc_tb = Column(Numeric(10,4), nullable=True)
    zc_hb = Column(Numeric(10,4), nullable=True)
    bzj_zl = Column(Numeric(18,2), nullable=True)
    bzj_tb = Column(Numeric(10,4), nullable=True)
    bzj_hb = Column(Numeric(10,4), nullable=True)
    tg_zl = Column(Numeric(18,2), nullable=True)
    tg_tb = Column(Numeric(10,4), nullable=True)
    tg_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_zc_unique', T_Ygb_Zc.yyb_id,T_Ygb_Zc.jzrq,T_Ygb_Zc.tjzq,T_Ygb_Zc.ywzl, unique=True)




class T_Ygb_Clkh (Base):
    __tablename__="T_YGB_CLKH" 
    id = Column(BigInteger, Sequence("seq_t_ygb_clkh_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    ywzl = Column(Integer, nullable=False)
    khs_cl = Column(Integer, nullable=True)
    khs_cl_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_1 = Column(Integer, nullable=True)
    khs_cl_1_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_1_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_1_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_2 = Column(Integer, nullable=True)
    khs_cl_2_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_2_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_2_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_3 = Column(Integer, nullable=True)
    khs_cl_3_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_3_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_3_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_4 = Column(Integer, nullable=True)
    khs_cl_4_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_4_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_4_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_5 = Column(Integer, nullable=True)
    khs_cl_5_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_5_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_5_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_6 = Column(Integer, nullable=True)
    khs_cl_6_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_6_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_6_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_7 = Column(Integer, nullable=True)
    khs_cl_7_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_7_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_7_hb = Column(Numeric(10,4), nullable=True)
    khs_cl_8 = Column(Integer, nullable=True)
    khs_cl_8_zb = Column(Numeric(10,4), nullable=True)
    khs_cl_8_tb = Column(Numeric(10,4), nullable=True)
    khs_cl_8_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_clkh_unique', T_Ygb_Clkh.yyb_id,T_Ygb_Clkh.jzrq,T_Ygb_Clkh.ywzl, unique=True)



class T_Ygb_Xzkh (Base):
    __tablename__="T_YGB_XZKH" 
    id = Column(BigInteger, Sequence("seq_t_ygb_xzkh_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    xz_zl = Column(Integer, nullable=True)
    xz_tb = Column(Numeric(10,4), nullable=True)
    xz_hb = Column(Numeric(10,4), nullable=True)
    xh_gr = Column(Integer, nullable=True)
    xh_gr_tb = Column(Numeric(10,4), nullable=True)
    xh_gr_hb = Column(Numeric(10,4), nullable=True)
    xh_jg = Column(Integer, nullable=True)
    xh_jg_tb = Column(Numeric(10,4), nullable=True)
    xh_jg_hb = Column(Numeric(10,4), nullable=True)
    xzkhzc = Column(Numeric(20,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_xzkh_unique', T_Ygb_Xzkh.yyb_id,T_Ygb_Xzkh.jzrq,T_Ygb_Xzkh.tjzq,T_Ygb_Xzkh.ywzl, unique=True)



class T_Ygb_Xhsj (Base):
    __tablename__="T_YGB_XHSJ" 
    id = Column(BigInteger, Sequence("seq_t_ygb_xhsj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    xh_zl = Column(Integer, nullable=True)
    xh_tb = Column(Numeric(10,4), nullable=True)
    xh_hb = Column(Numeric(10,4), nullable=True)
    xh_gr = Column(Integer, nullable=True)
    xh_gr_tb = Column(Numeric(10,4), nullable=True)
    xh_gr_hb = Column(Numeric(10,4), nullable=True)
    xh_jg = Column(Integer, nullable=True)
    xh_jg_tb = Column(Numeric(10,4), nullable=True)
    xh_jg_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_xhsj_unique', T_Ygb_Xhsj.yyb_id,T_Ygb_Xhsj.jzrq,T_Ygb_Xhsj.tjzq,T_Ygb_Xhsj.ywzl, unique=True)



class T_Ygb_Xzyxh (Base):
    __tablename__="T_YGB_XZYXH" 
    id = Column(BigInteger, Sequence("seq_t_ygb_xzyxh_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    xzhs_zl = Column(Integer, nullable=True)
    xzhs_tb = Column(Numeric(10,4), nullable=True)
    xzhs_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_xzyxh_unique', T_Ygb_Xzyxh.yyb_id,T_Ygb_Xzyxh.jzrq,T_Ygb_Xzyxh.tjzq,T_Ygb_Xzyxh.ywzl, unique=True)



class T_Ygb_Zcjlr (Base):
    __tablename__="T_YGB_ZCJLR" 
    id = Column(BigInteger, Sequence("seq_t_ygb_zcjlr_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    ywzl = Column(Integer, nullable=False)
    jlr_zl = Column(Numeric(18,2), nullable=True)
    jlr_tb = Column(Numeric(10,4), nullable=True)
    jlr_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ygb_zcjlr_unique', T_Ygb_Zcjlr.yyb_id,T_Ygb_Zcjlr.jzrq,T_Ygb_Zcjlr.tjzq,T_Ygb_Zcjlr.ywzl, unique=True)




class T_Otc_Cpx (Base):
    __tablename__="T_OTC_CPX" 
    id = Column(BigInteger, Sequence("seq_t_otc_cpx_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    zgm = Column(Numeric(18,2), nullable=True)
    zgm_tb = Column(Numeric(10,4), nullable=True)
    zgm_hb = Column(Numeric(10,4), nullable=True)
    zh = Column(Numeric(18,2), nullable=True)
    zh_tb = Column(Numeric(10,4), nullable=True)
    zh_hb = Column(Numeric(10,4), nullable=True)
    zq = Column(Numeric(18,2), nullable=True)
    zq_tb = Column(Numeric(10,4), nullable=True)
    zq_hb = Column(Numeric(10,4), nullable=True)
    yhlc = Column(Numeric(18,2), nullable=True)
    yhlc_tb = Column(Numeric(10,4), nullable=True)
    yhlc_hb = Column(Numeric(10,4), nullable=True)
    qslc = Column(Numeric(18,2), nullable=True)
    qslc_tb = Column(Numeric(10,4), nullable=True)
    qslc_hb = Column(Numeric(10,4), nullable=True)
    sypz = Column(Numeric(18,2), nullable=True)
    sypz_tb = Column(Numeric(10,4), nullable=True)
    sypz_hb = Column(Numeric(10,4), nullable=True)
    smjj = Column(Numeric(18,2), nullable=True)
    smjj_tb = Column(Numeric(10,4), nullable=True)
    smjj_hb = Column(Numeric(10,4), nullable=True)
    gmjj = Column(Numeric(18,2), nullable=True)
    gmjj_tb = Column(Numeric(10,4), nullable=True)
    gmjj_hb = Column(Numeric(10,4), nullable=True)
    zcgl = Column(Numeric(18,2), nullable=True)
    zcgl_tb = Column(Numeric(10,4), nullable=True)
    zcgl_hb = Column(Numeric(10,4), nullable=True)
    qt = Column(Numeric(18,2), nullable=True)
    qt_tb = Column(Numeric(10,4), nullable=True)
    qt_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_otc_cpx_unique', T_Otc_Cpx.yyb_id,T_Otc_Cpx.jzrq,T_Otc_Cpx.tjzq, unique=True)



class  (Base):
    __tablename__="" 
    id = Column(BigInteger, Sequence("seq__id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    zxsgm = Column(Numeric(18,2), nullable=True)
    zxsgm_tb = Column(Numeric(10,4), nullable=True)
    zxsgm_hb = Column(Numeric(10,4), nullable=True)
    wssc = Column(Numeric(18,2), nullable=True)
    wssc_tb = Column(Numeric(10,4), nullable=True)
    wssc_hb = Column(Numeric(10,4), nullable=True)
    app = Column(Numeric(18,2), nullable=True)
    app_tb = Column(Numeric(10,4), nullable=True)
    app_hb = Column(Numeric(10,4), nullable=True)
    dn = Column(Numeric(18,2), nullable=True)
    dn_tb = Column(Numeric(10,4), nullable=True)
    dn_hb = Column(Numeric(10,4), nullable=True)
    gt = Column(Numeric(18,2), nullable=True)
    gt_tb = Column(Numeric(10,4), nullable=True)
    gt_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data__unique', .yyb_id,.jzrq,.tjzq, unique=True)



class  (Base):
    __tablename__="" 
    id = Column(BigInteger, Sequence("seq__id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    bygm = Column(Numeric(18,2), nullable=True)
    bygm_tb = Column(Numeric(10,4), nullable=True)
    bygm_hb = Column(Numeric(10,4), nullable=True)
    byfe = Column(Numeric(18,2), nullable=True)
    byfe_tb = Column(Numeric(10,4), nullable=True)
    byfe_hb = Column(Numeric(10,4), nullable=True)
    zhgm = Column(Numeric(18,2), nullable=True)
    zhgm_tb = Column(Numeric(10,4), nullable=True)
    zhgm_hb = Column(Numeric(10,4), nullable=True)
    zhfe = Column(Numeric(18,2), nullable=True)
    zhfe_tb = Column(Numeric(10,4), nullable=True)
    zhfe_hb = Column(Numeric(10,4), nullable=True)
    zqgm = Column(Numeric(18,2), nullable=True)
    zqgm_tb = Column(Numeric(10,4), nullable=True)
    zqgm_hb = Column(Numeric(10,4), nullable=True)
    zqfe = Column(Numeric(18,2), nullable=True)
    zqfe_tb = Column(Numeric(10,4), nullable=True)
    zqfe_hb = Column(Numeric(10,4), nullable=True)
    yhlcgm = Column(Numeric(18,2), nullable=True)
    yhlcgm_tb = Column(Numeric(10,4), nullable=True)
    yhlcgm_hb = Column(Numeric(10,4), nullable=True)
    yhlcfe = Column(Numeric(18,2), nullable=True)
    yhlcfe_tb = Column(Numeric(10,4), nullable=True)
    yhlcfe_hb = Column(Numeric(10,4), nullable=True)
    qslcgm = Column(Numeric(18,2), nullable=True)
    qslcgm_tb = Column(Numeric(10,4), nullable=True)
    qslcgm_hb = Column(Numeric(10,4), nullable=True)
    qslcfe = Column(Numeric(18,2), nullable=True)
    qslcfe_tb = Column(Numeric(10,4), nullable=True)
    qslcfe_hb = Column(Numeric(10,4), nullable=True)
    sypzgm = Column(Numeric(18,2), nullable=True)
    sypzgm_tb = Column(Numeric(10,4), nullable=True)
    sypzgm_hb = Column(Numeric(10,4), nullable=True)
    sypzfe = Column(Numeric(18,2), nullable=True)
    sypzfe_tb = Column(Numeric(10,4), nullable=True)
    sypzfe_hb = Column(Numeric(10,4), nullable=True)
    smjjgm = Column(Numeric(18,2), nullable=True)
    smjjgm_tb = Column(Numeric(10,4), nullable=True)
    smjjgm_hb = Column(Numeric(10,4), nullable=True)
    smjjfe = Column(Numeric(18,2), nullable=True)
    smjjfe_tb = Column(Numeric(10,4), nullable=True)
    smjjfe_hb = Column(Numeric(10,4), nullable=True)
    gmjjgm = Column(Numeric(18,2), nullable=True)
    gmjjgm_tb = Column(Numeric(10,4), nullable=True)
    gmjjgm_hb = Column(Numeric(10,4), nullable=True)
    gmjjfe = Column(Numeric(18,2), nullable=True)
    gmjjfe_tb = Column(Numeric(10,4), nullable=True)
    gmjjfe_hb = Column(Numeric(10,4), nullable=True)
    zcglgm = Column(Numeric(18,2), nullable=True)
    zcglgm_tb = Column(Numeric(10,4), nullable=True)
    zcglgm_hb = Column(Numeric(10,4), nullable=True)
    zcglfe = Column(Numeric(18,2), nullable=True)
    zcglfe_tb = Column(Numeric(10,4), nullable=True)
    zcglfe_hb = Column(Numeric(10,4), nullable=True)
    qtgm = Column(Numeric(18,2), nullable=True)
    qtgm_tb = Column(Numeric(10,4), nullable=True)
    qtgm_hb = Column(Numeric(10,4), nullable=True)
    qtfe = Column(Numeric(18,2), nullable=True)
    qtfe_tb = Column(Numeric(10,4), nullable=True)
    qtfe_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data__unique', .yyb_id,.jzrq, unique=True)



class  (Base):
    __tablename__="" 
    id = Column(BigInteger, Sequence("seq__id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    dqzzgm = Column(Numeric(18,2), nullable=True)
    dzzzfe = Column(Numeric(18,2), nullable=True)
    zgm = Column(Numeric(18,2), nullable=True)
    zfe = Column(Numeric(18,2), nullable=True)
    gmzb = Column(Numeric(10,4), nullable=True)
    fezb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data__unique', .yyb_id,.jzrq, unique=True)



class  (Base):
    __tablename__="" 
    id = Column(BigInteger, Sequence("seq__id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    zdshgm = Column(Numeric(18,2), nullable=True)
    zdshgm_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data__unique', .yyb_id,.jzrq,.tjzq, unique=True)




class T_Wjb_Qdyl_Khsj (Base):
    __tablename__="T_WJB_QDYL_KHSJ" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_khsj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    qdlx = Column(Integer, nullable=False)
    zhs = Column(Integer, nullable=True)
    clhs = Column(Integer, nullable=True)
    zzc = Column(Numeric(20,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_khsj_unique', T_Wjb_Qdyl_Khsj.yyb_id,T_Wjb_Qdyl_Khsj.jzrq,T_Wjb_Qdyl_Khsj.tjzq,T_Wjb_Qdyl_Khsj.qdlx, unique=True)



class T_Wjb_Qdyl_Qdkh (Base):
    __tablename__="T_WJB_QDYL_QDKH" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_qdkh_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    qdlx = Column(Integer, nullable=False)
    zcs = Column(BigInteger, nullable=True)
    zcs_tb = Column(Numeric(10,4), nullable=True)
    zcs_hb = Column(Numeric(10,4), nullable=True)
    khs = Column(BigInteger, nullable=True)
    khs_tb = Column(Numeric(10,4), nullable=True)
    khs_hb = Column(Numeric(10,4), nullable=True)
    khs_gszs = Column(BigInteger, nullable=True)
    khs_gszb = Column(Numeric(10,4), nullable=True)
    khcgl = Column(Numeric(10,4), nullable=True)
    rjkhl = Column(Integer, nullable=True)
    khs_qdzb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_qdkh_unique', T_Wjb_Qdyl_Qdkh.yyb_id,T_Wjb_Qdyl_Qdkh.jzrq,T_Wjb_Qdyl_Qdkh.tjzq,T_Wjb_Qdyl_Qdkh.qdlx, unique=True)



class T_Wjb_Qdyl_Yxzh (Base):
    __tablename__="T_WJB_QDYL_YXZH" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_yxzh_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    qdlx = Column(Integer, nullable=False)
    yxzhs = Column(Integer, nullable=True)
    jyhs = Column(Integer, nullable=True)
    jyhs_tb = Column(Numeric(10,4), nullable=True)
    jyhs_hb = Column(Numeric(10,4), nullable=True)
    jyhl = Column(Numeric(10,4), nullable=True)
    jyhl_tb = Column(Numeric(10,4), nullable=True)
    jyhl_hb = Column(Numeric(10,4), nullable=True)
    rjhs = Column(Integer, nullable=True)
    rjhs_tb = Column(Numeric(10,4), nullable=True)
    rjhs_hb = Column(Numeric(10,4), nullable=True)
    rjhl = Column(Numeric(10,4), nullable=True)
    rjhl_tb = Column(Numeric(10,4), nullable=True)
    rjhl_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_yxzh_unique', T_Wjb_Qdyl_Yxzh.yyb_id,T_Wjb_Qdyl_Yxzh.jzrq,T_Wjb_Qdyl_Yxzh.tjzq,T_Wjb_Qdyl_Yxzh.qdlx, unique=True)



class T_Wjb_Qdyl_Khnl (Base):
    __tablename__="T_WJB_QDYL_KHNL" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_khnl_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    qdlx = Column(Integer, nullable=False)
    nlqd = Column(Integer, nullable=False)
    khs = Column(Integer, nullable=True)
    khs_zb = Column(Numeric(10,4), nullable=True)
    zc_rj = Column(Numeric(10,4), nullable=True)
    yj_rj = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_khnl_unique', T_Wjb_Qdyl_Khnl.yyb_id,T_Wjb_Qdyl_Khnl.jzrq,T_Wjb_Qdyl_Khnl.tjzq,T_Wjb_Qdyl_Khnl.qdlx,T_Wjb_Qdyl_Khnl.nlqd, unique=True)



class T_Wjb_Qdyl_Zcsj (Base):
    __tablename__="T_WJB_QDYL_ZCSJ" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_zcsj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    qdlx = Column(Integer, nullable=False)
    zzc = Column(Numeric(18,4), nullable=True)
    bzjye = Column(Numeric(18,4), nullable=True)
    tgsz = Column(Numeric(18,4), nullable=True)
    zzc_tb = Column(Numeric(10,4), nullable=True)
    zzc_hb = Column(Numeric(10,4), nullable=True)
    otczc = Column(Numeric(18,4), nullable=True)
    otczc_zb = Column(Numeric(10,4), nullable=True)
    xyzc = Column(Numeric(18,4), nullable=True)
    xyzc_zb = Column(Numeric(10,4), nullable=True)
    gjzc = Column(Numeric(18,4), nullable=True)
    gjzc_zb = Column(Numeric(10,4), nullable=True)
    hjzc = Column(Numeric(18,4), nullable=True)
    yxhjzc = Column(Numeric(18,4), nullable=True)
    jyj = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_zcsj_unique', T_Wjb_Qdyl_Zcsj.yyb_id,T_Wjb_Qdyl_Zcsj.jzrq,T_Wjb_Qdyl_Zcsj.tjzq,T_Wjb_Qdyl_Zcsj.qdlx, unique=True)



class T_Wjb_Qdyl_Zcfdsj (Base):
    __tablename__="T_WJB_QDYL_ZCFDSJ" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_zcfdsj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    qdlx = Column(Integer, nullable=False)
    zcfd = Column(Integer, nullable=False)
    zcze = Column(Numeric(10,4), nullable=True)
    bzjye = Column(Numeric(18,4), nullable=True)
    tgsz = Column(Numeric(18,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_zcfdsj_unique', T_Wjb_Qdyl_Zcfdsj.yyb_id,T_Wjb_Qdyl_Zcfdsj.jzrq,T_Wjb_Qdyl_Zcfdsj.qdlx,T_Wjb_Qdyl_Zcfdsj.zcfd, unique=True)



class T_Wjb_Qdyl_Zcjlr (Base):
    __tablename__="T_WJB_QDYL_ZCJLR" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_zcjlr_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    qdlx = Column(Integer, nullable=False)
    zcjlr = Column(Numeric(18,4), nullable=True)
    zcjlr_tb = Column(Numeric(10,4), nullable=True)
    zcjlr_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_zcjlr_unique', T_Wjb_Qdyl_Zcjlr.yyb_id,T_Wjb_Qdyl_Zcjlr.jzrq,T_Wjb_Qdyl_Zcjlr.tjzq,T_Wjb_Qdyl_Zcjlr.qdlx, unique=True)



class T_Wjb_Qdyl_Jysj (Base):
    __tablename__="T_WJB_QDYL_JYSJ" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_jysj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    qdlx = Column(Integer, nullable=False)
    cjl = Column(Numeric(18,4), nullable=True)
    cjl_tb = Column(Numeric(10,4), nullable=True)
    cjl_hb = Column(Numeric(10,4), nullable=True)
    gjcjl = Column(Numeric(18,4), nullable=True)
    gjcjl_tb = Column(Numeric(10,4), nullable=True)
    gjcjl_hb = Column(Numeric(10,4), nullable=True)
    gjzzl = Column(Numeric(18,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_jysj_unique', T_Wjb_Qdyl_Jysj.yyb_id,T_Wjb_Qdyl_Jysj.jzrq,T_Wjb_Qdyl_Jysj.tjzq,T_Wjb_Qdyl_Jysj.qdlx, unique=True)



class T_Wjb_Qdyl_Srsj (Base):
    __tablename__="T_WJB_QDYL_SRSJ" 
    id = Column(BigInteger, Sequence("seq_t_wjb_qdyl_srsj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    qdlx = Column(Integer, nullable=False)
    zsr = Column(Numeric(18,4), nullable=True)
    cpxssr = Column(Numeric(18,4), nullable=True)
    lxsr = Column(Numeric(18,4), nullable=True)
    jyj = Column(Numeric(18,4), nullable=True)
    jyj_tb = Column(Numeric(10,4), nullable=True)
    jyj_hb = Column(Numeric(10,4), nullable=True)
    jcjl = Column(Numeric(18,4), nullable=True)
    jyjl = Column(Numeric(18,4), nullable=True)
    hjcs = Column(Numeric(18,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wjb_qdyl_srsj_unique', T_Wjb_Qdyl_Srsj.yyb_id,T_Wjb_Qdyl_Srsj.jzrq,T_Wjb_Qdyl_Srsj.tjzq,T_Wjb_Qdyl_Srsj.qdlx, unique=True)




class T_Ehtc_Clzjl (Base):
    __tablename__="T_EHTC_CLZJL" 
    id = Column(BigInteger, Sequence("seq_t_ehtc_clzjl_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    khs = Column(BigInteger, nullable=True)
    khs_tb = Column(Numeric(10,4), nullable=True)
    khs_hb = Column(Numeric(10,4), nullable=True)
    khs_zb = Column(Numeric(10,4), nullable=True)
    sbs = Column(BigInteger, nullable=True)
    sbs_tb = Column(Numeric(10,4), nullable=True)
    sbs_hb = Column(Numeric(10,4), nullable=True)
    sbs_zb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ehtc_clzjl_unique', T_Ehtc_Clzjl.yyb_id,T_Ehtc_Clzjl.jzrq, unique=True)



class T_Ehtc_Xzzjl (Base):
    __tablename__="T_EHTC_XZZJL" 
    id = Column(BigInteger, Sequence("seq_t_ehtc_xzzjl_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    khs = Column(BigInteger, nullable=True)
    khs_tb = Column(Numeric(10,4), nullable=True)
    khs_hb = Column(Numeric(10,4), nullable=True)
    khs_zb = Column(Numeric(10,4), nullable=True)
    sbs = Column(BigInteger, nullable=True)
    sbs_tb = Column(Numeric(10,4), nullable=True)
    sbs_hb = Column(Numeric(10,4), nullable=True)
    sbs_zb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ehtc_xzzjl_unique', T_Ehtc_Xzzjl.yyb_id,T_Ehtc_Xzzjl.jzrq,T_Ehtc_Xzzjl.tjzq, unique=True)



class T_Ehtc_Syqk (Base):
    __tablename__="T_EHTC_SYQK" 
    id = Column(BigInteger, Sequence("seq_t_ehtc_syqk_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    jyl = Column(Numeric(18,2), nullable=True)
    jyl_zb = Column(Numeric(10,4), nullable=True)
    wtl = Column(Numeric(18,2), nullable=True)
    wtl_zb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_ehtc_syqk_unique', T_Ehtc_Syqk.yyb_id,T_Ehtc_Syqk.jzrq,T_Ehtc_Syqk.tjzq, unique=True)




class T_Eshop (Base):
    __tablename__="T_ESHOP" 
    id = Column(BigInteger, Sequence("seq_t_eshop_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    xsrs = Column(BigInteger, nullable=True)
    xsrs_tb = Column(Numeric(10,4), nullable=True)
    xsrs_hb = Column(Numeric(10,4), nullable=True)
    xsl = Column(Numeric(18,2), nullable=True)
    xsl_tb = Column(Numeric(10,4), nullable=True)
    xsl_hb = Column(Numeric(10,4), nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_eshop_unique', T_Eshop.yyb_id,T_Eshop.jzrq,T_Eshop.tjzq, unique=True)



class T_Wx_Fw_Yysj (Base):
    __tablename__="T_WX_FW_YYSJ" 
    id = Column(BigInteger, Sequence("seq_t_wx_fw_yysj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    fs_rs = Column(Integer, nullable=True)
    fs_zzs = Column(Integer, nullable=True)
    fs_zzl = Column(Numeric(10,8), nullable=True)
    kh_zl = Column(Integer, nullable=True)
    kh_jzzs = Column(Integer, nullable=True)
    kh_jzzl = Column(Numeric(10,8), nullable=True)
    tsrs = Column(BigInteger, nullable=True)
    zxfbs = Column(BigInteger, nullable=True)
    yds = Column(BigInteger, nullable=True)
    pu = Column(BigInteger, nullable=True)
    uv = Column(BigInteger, nullable=True)
    ip = Column(BigInteger, nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wx_fw_yysj_unique', T_Wx_Fw_Yysj.yyb_id,T_Wx_Fw_Yysj.jzrq,T_Wx_Fw_Yysj.tjzq, unique=True)



class T_Wx_Dy_Yysj (Base):
    __tablename__="T_WX_DY_YYSJ" 
    id = Column(BigInteger, Sequence("seq_t_wx_dy_yysj_id"),primary_key=True)
    yyb_id = Column(Integer, nullable=False)
    jzrq = Column(DateTime, nullable=False)
    tjzq = Column(Integer, nullable=False)
    fs_rs = Column(Integer, nullable=True)
    fs_zzs = Column(Integer, nullable=True)
    fs_zzl = Column(Numeric(10,8), nullable=True)
    kh_zl = Column(Integer, nullable=True)
    kh_jzzs = Column(Integer, nullable=True)
    kh_jzzl = Column(Numeric(10,8), nullable=True)
    tsrs = Column(BigInteger, nullable=True)
    zxfbs = Column(BigInteger, nullable=True)
    yds = Column(BigInteger, nullable=True)
    pu = Column(BigInteger, nullable=True)
    uv = Column(BigInteger, nullable=True)
    ip = Column(BigInteger, nullable=True)
    create_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False ,default=datetime.datetime.now())
Index('data_t_wx_dy_yysj_unique', T_Wx_Dy_Yysj.yyb_id,T_Wx_Dy_Yysj.jzrq,T_Wx_Dy_Yysj.tjzq, unique=True)




